----------------------------------------------
-- @name: index_fast_full_scan
-- @author: dion cho
-- @descripiotn: test for index fast full scan
----------------------------------------------

drop table t1 purge;

create table t1(c1 int, c2 int)
partition by hash(c1)
partitions 4
;

create index t1_n1 on t1(c1)
local
--global partition by hash(c1) partitions 4
;

insert into t1
select level, level
from dual
connect by level <= 10000
;

commit;

@gather t1

explain plan for
select /*+ index_ffs(t1)  */
 c1
from t1
where c1 > 0
;

@plan

explain plan for
select /*+ index_ffs(t1) parallel(t1) */
 c1
from t1
where c1 > 0
;

@plan

alter index t1_n1 parallel;

explain plan for
select /*+ index_ffs(t1)  */
 c1
from t1
where c1 > 0
;

@plan

